﻿using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Web;
using OfficeOpenXml;

namespace UploadPlugin.Models
{
    public class Report
    {
        public string Name
        {
            get { return "SimpleReport"; }
        }

        public Report()
        { }
        
        public MemoryStream GetReport()
        {
            //using (
            var excel = new MemoryStream(Resources.ReportsResources.bn46); //blank2);//)
            //{
            //var pckg = new ExcelPackage(excel);
                
                //excel.Close();
                //pckg.Save();
                //return pckg;
            
            //}
            //pckg.Workbook.Worksheets.First().Cells[10, 2].Value = "Some useful info";
            //pckg.Save();
            //return pckg;
            
            //return new MemoryStream(pckg.GetAsByteArray());
            return excel;
        }
    }
}